速報APP / 教育 / Database Management System

Database Management System

價格:免費

更新日期:2018-10-31

檔案大小:11M

目前版本:2.2

版本需求:Android 4.0.3 以上版本

官方網站:http://www.softecks.in

Email:contact@softecks.in

聯絡地址:201-B,Nishadham Blgd,1/5, Chipale,Panvel,Navi Mumbai-410206,Maharashtra, India

Database Management System(圖1)-速報App

✴ A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.✴

► A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.✦

【Topics Covered in this App are Listed Below】

⇢ Overview

⇢ Architecture

⇢ Data Models

⇢ Data Schemas

⇢ Data Independence

⇢ ER Model - Basic Concepts

⇢ ER Diagram Representation

⇢ Generalization Aggregation

⇢ Codd's 12 Rules

⇢ Relation Data Model

⇢ Relational Algebra

⇢ ER Model to Relational Model

Database Management System(圖2)-速報App

⇢ SQL Overview

⇢ Normalization

⇢ Joins

⇢ Storage System

⇢ File Structure

⇢ Indexing

⇢ Hashing

⇢ Transaction

⇢ Concurrency Control

⇢ Deadlock

⇢ Data Backup

⇢ Data Recovery

Database Management System(圖3)-速報App

⇢ What is a Database Management System?

⇢ Who Interacts with a DBMS?

⇢ Components of a Database System

⇢ Basic Set Concepts

⇢ DBMS Database Models

⇢ Database Keys

⇢ What is First Normal Form (1NF)?

⇢ What is Second Normal Form?

⇢ Third Normal Form (3NF)

⇢ Boyce-Codd Normal Form (BCNF)

⇢ Fourth Normal Form (4NF)

⇢ create command

⇢ ALTER command

⇢ Truncate, Drop or Rename a Table

⇢ INSERT SQL command

⇢ UPDATE SQL command

Database Management System(圖4)-速報App

⇢ DELETE SQL command

⇢ Commit, Rollback and Savepoint SQL commands

⇢ GRANT and REVOKE

⇢ SELECT SQL Query

⇢ WHERE SQL clause

⇢ SQL LIKE clause

⇢ ORDER BY Clause

⇢ Group By Clause

⇢ HAVING Clause

⇢ DISTINCT keyword

⇢ AND & OR operator

⇢ Division Operator in SQL

⇢ SQL Constraints

⇢ What are SQL Functions?

⇢ Scalar Functions

⇢ SQL Alias - AS Keyword

Database Management System(圖5)-速報App

⇢ SET Operations in SQL

⇢ What is an SQL Sequence?

⇢ SQL VIEW

Database Management System(圖6)-速報App